ocr: Scenario Cost Rule 1) PK: and FK indexes only 8,822 21,050 5: Figure 2) Index per uimension column 9,133 2,704 Perfor- 3): - Switch IN to JEIWEEN 8,923 1,162 mance 4) Star Optimizer Hint 9,323 1,222 results. 5) FROM clause order 10,545 871 6) force YEAR index Usage 10,164 211